How to: Set Up Stock Coverage

Stock Coverage is a functionality which enables users to calculate how long a store is able to continue selling items or groups of items given a sales history and inventory. A Coverage Goal (weeks) can be set up in the Stock Coverage page per item category or product group, as well as for a specific season. When the Stock Coverage is set up for a specific season, its Ending Date follows the ending date for that season and the Coverage Goal (weeks) is then automatically calculated. The Weekly Sales Qty. is calculated based on the No. of Sales Days to Analyse field in Replenishment Setup.

To set up No. of Sales Days to Analyze

  1. Navigate to LS Retail – Replenishment, General, Administration - Replenishment Setup.
  2. Fill in the No. of Sales Days to Analyse field in the Stock Coverage FastTab. This field defines how many days to go back in history for Weekly Sales Qty. calculation in Stock Coverage.

Note: If the Stock Coverage is only set up for a specific season, make sure that the Season Code field in the Retail Item Card is filled for all affected seasonal items.

To set up Stock Coverage

The Stock Coverage page is accessible with the Stock Coverage action found in:

  • Location List page, which can be accessed by navigating to LS Retail - Replenishment, Automatic, Administration - Locations.
  • Retail Item Categories page, which can be accessed by navigating to LS Retail - BackOffice, Product Design, Administration - Groups - Item Categories.
  • Retail Product Groups page, which can be accessed by navigating to LS Retail - BackOffice, Product Design, Administration - Groups - Product Groups.
  • Seasons page, which can be accessed by navigating to LS Retail - BackOffice, Product Design, Administration - Groups - Seasons.
  1. Open the Stock Coverage page by clicking on the Stock Coverage action.
  2. Fill in the Location Code.
  3. Fill in the Item Category Code.
  4. Fill in the Product Group Code, if needed.
  5. Fill in the Season Code if the coverage is set up for a specific season. The Ending Date is automatically updated from the season.
  6. Update the Ending Date manually, if needed.
  7. The Goal (weeks), which is the coverage goal for the item category or product group, is automatically calculated as the difference (in terms of weeks) between the Ending Date and Work date. Manually overwrite the value if needed.
  8. Repeat steps 2 to 7 for each Stock Coverage you want to create.
  9. Click on the Calculate Coverage action in the Process group to calculate and update the value for Weekly Sales Qty., Actual (weeks) and Coverage %. For more information please refer to How to: Calculate Stock Coverage.

Note: The Last Time Calculated field indicates the date and time of the last Calculate Coverage action performed.

See Also

Stock Coverage

Lifecycle Planning Worksheet